| IsirSummary |
| EntityType | Independent |
| Logical Entity Name | IsirSummary |
| Default Table Name | FaISIRMain |
| Logical Only | NO |
| Definition | |
| Note |
| IsirSummary Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
IsirAwardYearSchemaId |
INTEGER | NO | ||
| BatchIdentifier | VARCHAR(30) | YES | ||
| TransactionIdentifier | CHAR(13) | NO | ||
| ISIRSsn | VARCHAR(30) | NO | ||
| IsirDateOfBirth | DATETIME | YES | ||
| ISIRFirstName | VARCHAR(12) | NO | ||
| ISIRLastName | VARCHAR(50) | NO | ||
| EnrollmentStatus | CHAR(1) | NO | ||
| PrimaryEFC | VARCHAR(10) | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| ISIRRecordStatus | TINYINT | NO | ||
| VerificationComplete | CHAR(1) | NO |
| IsirSummary Keys |
| Key Name | Key Type | Keys |
| IDX_FaISIRMain_ISIRSsn | Inversion Entry | ISIRSsn |
| UK_FaISIRMain_TransactionId_FaIsirAwardYearSchemaId | Unique Constraint | TransactionIdentifier, IsirAwardYearSchemaId |
| NK_FaISIRMain_UserId | Inversion Entry | LastModifiedUserId |
| NK_FaISIRMain_FaISIRAwardYearSchemaId | Inversion Entry | IsirAwardYearSchemaId |
| PK_FaISIRMain_FaISIRMainId | PrimaryKey | Id |
| IsirSummary Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| IsirAwardYearSchema | Non-Identifying | One To Zero or More | IsirAwardYearSchemaId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FaISIRNSLDSData | Non-Identifying | One To Zero or More | NO | ||||
| IsirCalculatedEfc | Non-Identifying | One To Zero or More | NO | ||||
| IsirCorrection | Non-Identifying | One To Zero or More | NO | ||||
| FaIsirCpsVerificationGroup | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRData | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRImportTrackLog | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRNSLDSGrantData | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRNSLDSGrantSparseData | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRNSLDSLoanData | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRNSLDSLoanSparseData | Non-Identifying | One To Zero or More | NO | ||||
| FaISIRNSLDSSparseData | Non-Identifying | One To Zero or More | NO | ||||
| IsirRawData | Non-Identifying | One To Zero or More | NO | ||||
| IsirMatch | Non-Identifying | One To Zero or More | NO | ||||
| IsirVerification | Non-Identifying | One To Zero or More | NO |
| IsirSummary Check Constraints |
| Check Constraint Name | CheckConstraint |